<?php
define('BASE_PATH',str_replace('\\','/',realpath(dirname(__FILE__).'/'))."/");
?>
<!DOCTYPE html>
<html>
	<head>
		<meta charset="utf-8" />
		<title></title>
		<link rel="stylesheet" type="text/css" href="css/bootstrap.min.css">
		<link rel="stylesheet" type="text/css" href="css/bootstrap-theme.min.css">
		<script type="text/javascript" src="js/jquery-3.1.1.js"></script>
		<script type="text/javascript" src="js/bootstrap.min.js"></script>
	</head>
<body>
<?php
	session_start();
	if(isset($_SESSION['username'])){
?>
	<div class="container">
	<div class="row clearfix">
		<div class="col-md-12 column">
			<ul class="nav nav-tabs" style="padding: 2%;">
				<li>
					<a href="#" data-toggle="dropdown" class="dropdown-toggle">查看信息<strong class="caret"></strong></a>
					<ul class="dropdown-menu">
						<li>
							 <a href="ck/ckbks.php">本科生</a>
						</li>
						<li>
							 <a href="ck/ckyjs.php">研究生</a>
						</li>
						<li>
							 <a href="ck/ckbss.php">博士生</a>
						</li>
					</ul>
				</li>
				<li>
					<a href="#" data-toggle="dropdown" class="dropdown-toggle">预修改信息<strong class="caret"></strong></a>
					<ul class="dropdown-menu">
						<li>
							 <a href="#">本科生</a>
						</li>
						<li>
							 <a href="#">研究生</a>
						</li>
						<li>
							 <a href="#">博士生</a>
						</li>
					</ul>
				</li>
				<li>
					<a href="#" data-toggle="dropdown" class="dropdown-toggle">预修改信息审核<strong class="caret"></strong></a>
					<ul class="dropdown-menu">
						<li>
							 <a href="#">本科生</a>
						</li>
						<li>
							 <a href="#">研究生</a>
						</li>
						<li>
							 <a href="#">博士生</a>
						</li>
					</ul>
				</li>
				<li>
					<a href="#" data-toggle="dropdown" class="dropdown-toggle">直接修改信息<strong class="caret"></strong></a>
					<ul class="dropdown-menu">
						<li>
							 <a href="xg/xgbks.php">本科生</a>
						</li>
						<li>
							 <a href="xg/xgyjs.php">研究生</a>
						</li>
						<li>
							 <a href="xg/xgbss.php">博士生</a>
						</li>
					</ul>
				</li>
				<li class="dropdown pull-right">
					 <a href="#" data-toggle="dropdown" class="dropdown-toggle">用户<strong class="caret"></strong></a>
					<ul class="dropdown-menu">
						<li>
							 <a href="#">更改密码</a>
						</li>
						<li class="divider">
						</li>
						<li>
							 <a href="logout.php">注销</a>
						</li>
					</ul>
				</li>
			</ul>
			<ul class="breadcrumb">
				<li>
					 <a href="#">Home</a>
				</li>
				<li>
					 <a href="#">Library</a>
				</li>
				<li class="active">
					Data
				</li>
			</ul>
			<table class="table table-hover">
				<thead>
					<tr>
						<th><font color=black>学号</font></th>
						<th><font color=black>姓名</font></th>
						<th><font color=black>高中学籍材料</font></th>
						<th><font color=black>高考报名登记表</font></th>
						<th><font color=black>高考体格检查表</font></th>
						<th><font color=black>大学生登记表</font></th>
						<th><font color=black>师范生免费教育协议书</font></th>
						<th><font color=black>军训考核成绩表</font></th>
						<th><font color=black>入团志愿书</font></th>
						<th><font color=black>入党志愿书</font></th>
						<th><font color=black>入党申请书</font></th>
						<th><font color=black>入党其它材料</font></th>
						<th><font color=black>其它材料</font></th>
						<th><font color=black>备注</font></th>
					</tr>
				</thead>
	<tbody>
<?php 	
	$username = "root";
	$pwd = "root";
	$con = mysql_connect("localhost",$username,$pwd);
	if (!$con)
	{
		die('Could not connect: ' . mysql_error());
	}
	mysql_select_db("dag", $con);
	mysql_query("SET NAMES 'utf8'");
	$result = mysql_query("SELECT * FROM bachelor");
	while($row = mysql_fetch_array($result))
		{?>
	<tr>
		<td><font color=black><?=$row['xh'] ?></font></td>
		<td style="width: 60px"><font color=black><?=$row['xm'] ?></font></td>
		<td><font color=black><?=$row['gzxj'] ?></font></td>
		<td><font color=black><?=$row['gkbm'] ?></font></td>
		<td><font color=black><?=$row['gktj'] ?></font></td>
		<td><font color=black><?=$row['dxsdjb'] ?></font></td>
		<td><font color=black><?=$row['msxy'] ?></font></td>
		<td><font color=black><?=$row['jxkh'] ?></font></td>
		<td><font color=black><?=$row['rtzys'] ?></font></td>
		<td><font color=black><?=$row['rdzys'] ?></font></td>
		<td><font color=black><?=$row['rdsqs'] ?></font></td>
		<td><font color=black><?=$row['rdqtcl'] ?></font></td>
		<td><font color=black><?=$row['qtcl'] ?></font></td>
		<td><font color=black><?=$row['bz'] ?></font></td>
	</tr>	
	<?}?>		
		</tbody>
		</table>
		</div>
	</div>
</div>
<?php }else{?>
<script>
	alert("请登录");
	window.location.href = 'login.html';
</script>
<?}?>
</body>
</html>
